﻿using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
namespace OneMake.Model
{
    [PetaPoco.TableName("ppf_d_joeone_sales")]
    [PetaPoco.PrimaryKey("oid")]
    public class ppf_d_joeone_sales
    {
        [MapToField(FieldName = "统计日期")]
        public DateTime stat_datetime { get; set; }

        [MapToExcel(ColumnName = "订单日期")]
        public DateTime order_date { get; set; }

        [MapToExcel(ColumnName = "订单编号")]
        public string order_sn { get; set; }

        [MapToExcel(ColumnName = "源订单编号")]
        public string source_order_sn { get; set; }

        [MapToExcel(ColumnName = "商品货号")]
        public string prd_sn { get; set; }

        [MapToExcel(ColumnName = "商品名称")]
        public string prd_name { get; set; }

        [MapToExcel(ColumnName = "颜色")]
        public string color { get; set; }

        [MapToExcel(ColumnName = "尺码")]
        public string size { get; set; }

        [MapToExcel(ColumnName = "系统SKU码")]
        public string sys_sku { get; set; }

        [MapToExcel(ColumnName = "企业SKU码")]
        public string company_sku { get; set; }

        [MapToExcel(ColumnName = "商品条码")]
        public string prd_serial { get; set; }

        [MapToExcel(ColumnName = "数量")]
        public int num { get; set; }

        [MapToExcel(ColumnName = "单价(元)")]
        public double price { get; set; }

        [MapToExcel(ColumnName = "金额(元)")]
        public double amount { get; set; }

        [MapToExcel(ColumnName = "分摊金额(元)")]
        public double avg_amount { get; set; }
        
		/////////////////////////////////////////
        [MapToField(FieldName = "门店编号")]
        public int shopid { get; set; }
        [MapToField(FieldName = "文件编号")]
        public int fileid { get; set; }
        [MapToField(FieldName = "编号")]
        public int oid { get; private set; }    
    }
}